﻿CREATE TABLE [dbo].[tblWH_Config]
(
	[cfg_id]					int IDENTITY(1,1)			NOT NULL,		--- Change the seed on each MSX server if multiple MSX servers.  Change the increment to be equal # of MSX servers.
	[cfg_ssd_id]				int							NOT NULL,
	[cfg_recover_window_days]	int							NOT NULL,
	[cfg_bkp_skip_db]			nvarchar(MAX)				NULL,
	[cfg_maint_skip_db]			nvarchar(MAX)				NULL,
	[cfg_maint_nomove_ndx]		nvarchar(MAX)				NULL,
	[cfg_bkp_prescript]			nvarchar(MAX)				NULL, 
	[cfg_bkp_postscript]		nvarchar(MAX)				NULL,
	[cfg_local_domain]			nvarchar(512)				NULL,
	[cfg_max_server_RAM]		int							NULL,
	CONSTRAINT					PK_tblWH_Config				PRIMARY KEY CLUSTERED (cfg_id ASC)
)
GO
CREATE INDEX [IX_tblWH_Config_ssdid] ON [dbo].[tblWH_Config] ([cfg_ssd_id])
GO